set hive.exec.dynamic.partition=true;--动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=20;--每天生成 20 个分区
set hive.exec.max.dynamic.partitions.pernode=20;--每天生成 20 个分区
insert overwrite table jms_dim.dim_tab_ops_star_rank_config_dt partition(dt)
select
id
,one_star_score_min
,one_star_score_max
,two_star_score_min
,two_star_score_max
,three_star_score_min
,three_star_score_max
,four_star_score_min
,four_star_score_max
,five_star_score_min
,effect_start_time
,effect_end_time
,immediately_effect
,five_star_score_max
,throwaway_collect_score
,throwaway_collect_score_limit
,cancel_score
,cancel_score_limit
,timely_sign_one_votes_min
,timely_sign_one_votes_max
,timely_sign_one_score
,timely_sign_one_target
,timely_sign_one_floors
,timely_sign_one_limit
,timely_sign_two_votes_min
,timely_sign_two_votes_max
,timely_sign_two_score
,timely_sign_two_target
,timely_sign_two_floors
,timely_sign_two_limit
,timely_sign_three_votes_min
,timely_sign_three_votes_max
,timely_sign_three_score
,timely_sign_three_target
,timely_sign_three_floors
,timely_sign_three_limit
,customer_complaint_score
,service_attitude_score
,customer_complaint_limit
,lose_score
,lose_limit
,work_clothes_check_add_score
,work_clothes_check_add_limit
,work_clothes_check_sub_score
,work_clothes_check_sub_limit
,create_time
,create_staff_code
,create_staff_name
,create_network_code
,create_network_name
,update_time
,update_staff_code
,update_staff_name
,update_network_code
,update_network_name
,throwaway_collect_is_enable
,cancel_is_enable
,timely_sign_is_enable
,customer_complaint_is_enable
,lose_is_enable
,work_clothes_check_is_enable
,status
,label_must_call_rate_score
,label_must_call_rate_target
,label_must_call_rate_limit
,five_question_score
,label_must_call_rate_enable
,five_question_enable
,label_must_call_rate_floors
,dt
from jms_ods.tab_ops_star_rank_config
where dt = '{{ execution_date | cst_ds }}'